If (Int ((Return Date - Absence Date) / 7) * 5 + Mod (Return Date - Absence Date, 7) - If (Mod (Return Date - Date (1, 3, 1904), 7) < Mod (Absence Date - Date (1, 3, 1904), 7), 2, 0) - (Lookup High - Lookup Lowkup Low, 7), 2, 0) - (Lookup High - Lookup Low
Lookup LowB
Holidays.FMg
CREATION DATE
DAYS ABSENT
EMPLOYEE NUMBER
HIRE DATE
HIRE DATE PLUS NINETY
INSTRUCTION CODE
INSTRUCTIONS
LAST ANNIVERSARY DATE
RECORD TYPE
RETURN DATE
SD NEW ACCRUAL DATE
1 New Sick Leave
2 Total Absences for Employee
3 Continue New Sick Leave
4 Finish New Sick Leave
5 New Vacation Leave
Total Days AbsentB
SD Previous BalanceB
SD New BalanceB
A!SD Previous Balance - Days Absent
SD New Accrual DateB
Date (Month (Creation Date) + If (Day (Creation Date) < Day (Hire Date + 90), -1, 0), Day (Hire Date + 90), Year (Creation Date))
%"te))
Posting
CANCEL
New Balance
Employee Number:
Absence Date
Creation Date
Days Absent
Employee Number
Record Type
SD New Balance
SD Previous Balance
Days Absent
VacationB
5 New Vacation Leave
Vacation
Vacation
Lookup LowB
Holidays.FMg
Lookup LowB
Holidays.FMg
New Balance
Employee Number:
6/1/95
ABSENCE DATE
7/8/94
ABSENCE DATE
7/8/94
ABSENCE DATE
DAYS ABSENT
EMPLOYEE NUMBER
HIRE DATE
LOOKUP HIGH
LOOKUP LOW
RETURN DATE
SD ACCRUAL MO?
SD NEW ACCRUAL DATE
1 New Sick Leave
Absence
2 Total Absences for Employee
Absence
Absence
5 New Vacation Leave
Instruction CodeB
Hire Date plus ninetyB
Day (Hire Date + 90)
Instruction CodeB
'^Enter Start Date, End Date, and Days Absent. Use TAB to change fields, press ENTER when done!'
Instruction CodeB
VT Previous BalanceB
VT New BalanceB
A_If (Instruction Code = 1, VT Previous Balance + Days Absent, VT Previous Balance - Days Absent)
EMPLOYEE.FMg
Creation DateB
Last Anniversary DateB
(Hire Date + 90), 2) = 0, 1, 0)
Creation DateB
Last Anniversary DateB
@1A Sick Days
Vacation Days
Date (Month (Hire Date), Day (Hire Date), If (Today < Date (Month (Hire Date), Day (Hire Date), Year (Today)), Year (Today) - 1, Year (Today)))
Record TypeB
Vacation
Absence
InstructionsB
If (Instruction Code = "1", "Enter Start Date, and Days Absent (to be converted to vacation time", If (Instruction Code = "2", "Sick leave converted to Vacation Time", If (Instruction Code = "3", "Vactation tim
Date Employee Returned:
Days Absent :
Total Days Vacation:
Employee Number:
Posting
CANCEL
1 New Sick Leave
2 Total Absences for Employee
3 Continue New Sick Leave
4 Finish New Sick Leave
5 New Vacation Leave
6 Finish Vacation Leave
7 Total Vacation for Employee
8 New Sick Leave Rollover
9 Finish Sick Leave Rollover
10 Vacation Leave Rollover
11 Cancel
Helvetica
Geneva
Arial Narrow
Times
Arial
Converted
Enter
Start
Vacation
Change
Enter
Fields
Press
Start
Date Absence Began:
Date Employee Returned:
Days Absent :
Total Days Absent
Previous Balance
New Balance
Employee Number:
Number:
Date Employee Returned:
Days Absent :
Total Days Absent
Previous Balance
New Balance
Employee Number:
A Hire DateB
A Hire DateB
), Day (Hire Date + 90), Year (Creation Date))
A Hire DateB
7 Total Vacation for Employee
Vacation
8 New Sick Leave Rollover
AbsenceB
9 Finish Sick Leave Rollover
10 Vacation Leave Rollover
YesfT
YesfT
1/15/95C
2/10/95D
04/21/95L
7/23/89P
5/17/95Q
07/23/94R
AbsenceS^Enter Start Date, End Date, and Days Absent. Use TAB to change fields, press ENTER when done!T
2/11/95C
2/17/95D
04/21/95L
7/23/89P
5/17/95Q
07/23/94R
VacationS^Enter Start Date, End Date, and Days Absent. Use TAB to change fields, press ENTER when done!T
04/21/95L
7/23/89P
5/18/95Q
07/23/94R
Absence
YesfT
YesfT
YesfT
YesfT
YesfT
Absence ReportB
YesfT
YesfT
YesfT
YesfT
R when done!W
8/1/94C
8/3/94D
3 Continue New Sick Leave
4 Finish New Sick Leave
6 Finish Vacation Leave
Vacation Leave
Pro 2.0 - 2.1F!
Pro 2.0 - 2.1I
US English - Spelling
User Dictionary
/01/95
e, and Days Absent. Use TAB to change fields, press ENTER when done!T
hen done!T
4/94G
10/01/94
YesfT
YesfT
Vacation DaysB
Vacation DaysB
A Sick Days
Vacation Days
Absence Report
A Sick DaysB
YesfT
CREATION DATE
SD NEW BALANCE
A 11 Cancel
469Q
07/23/94R
Vacation
VacationB
VacationW
Absent
Changet
DaysJ
DoneD
Enter
Fieldsv
Press[
Start
e converted from Sick Leave", "Enter Start Date, End Date, and Days Absent. Use TAB to change fields, press ENTER when done!")))
'CEnter Start Date, and Days Absent (to be converted to vacation time
'%Sick leave converted to Vacation Time
'(Vactation time converted from Sick Leave'^Enter Start Date, End Date, and Days B<Absent. Use TAB to change fields, press ENTER when done!